ocr: Categories Column Data Type CategoryiD (primary key) AutoNumber Cotegory Text (30) sortrosition Byte Products Column Data Type temNumber (primary key) AutoNumber Manutacturer Text (30) Model Text (35) Year Date/lime CategoryID Long Integer Description Memo Price Currency ExpirationDate DateTime Status Text (10) Figure 2: The structures of the two tables.